First Day of the month
Hi,
You may also try this
=EOMONTH(F7,-1)+1
You may need to install the analysis Toolpak for the eomonth function to
work
--
Regards,
Ashish Mathur
Microsoft Excel MVP
"Jen_T" wrote in message
...
Does anyone know how to have excel look at a cell that has a date that is
formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as
01/01/2007 in B2, another words view as date as first day of the month.
|