Date formula
Closed
@vi
Posts
1
Registration date
Monday December 16, 2013
Status
Member
Last seen
December 16, 2013
-
Dec 16, 2013 at 02:37 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 18, 2013 at 11:57 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 18, 2013 at 11:57 PM
Related:
- Date formula
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 18, 2013 at 11:57 PM
Dec 18, 2013 at 11:57 PM
first of all in excel DATE SHOULD BE ENTERED AS EXCEL DATE. for e.g.
1 dec 2013 should be entered either as 12/1/13 or 1/12/13 according to your regional configuration of your computer(see control panel - region and language)
in exccel 2007 there is an inbuilt function EOMONTH.
if A1 has entry 12/1/13 (1st dec 2013) then in any empty cell if you type
=EOMONTH(A1,0)
You will get 12/31/13 whllch is 31st dec 2013
1 dec 2013 should be entered either as 12/1/13 or 1/12/13 according to your regional configuration of your computer(see control panel - region and language)
in exccel 2007 there is an inbuilt function EOMONTH.
if A1 has entry 12/1/13 (1st dec 2013) then in any empty cell if you type
=EOMONTH(A1,0)
You will get 12/31/13 whllch is 31st dec 2013
