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 |
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 |
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 |
a moth before
|
All times are GMT +1. The time now is 02:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com