Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
a moth before
I need to have a cell that shows a moth before today
=today () 'it shows 30-july i need to have = June How ca do it? Thanks John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
a moth before
John this should do it =DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))
-- Paul B Always backup your data before trying something new Using Excel 2000 & 97 Please post any response to the newsgroups so others can benefit from it ** remove news from my email address to reply by email ** "John" wrote in message ... I need to have a cell that shows a moth before today =today () 'it shows 30-july i need to have = June How ca do it? Thanks John |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
a moth before
=EOMONTH(B4,-1)
Also Format, Cell, Custom "mmmm" HTH "John" wrote in message ... I need to have a cell that shows a moth before today =today () 'it shows 30-july i need to have = June How ca do it? Thanks John |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
a moth before
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rolling 12 moth formula | Excel Discussion (Misc queries) |