Alex has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course
Excel 2013
How do you convert a date field in a excel document to show the numeric value 1 (if a date is present) and an empty field to show 0.
RE: Excel 2013
Hi Alex,
Thank you for the forum question.
You will have to use a separate column.
If your dates or empty cells are in column A use the IsNumber function like this:
=--Isnumber(A2)
This will return 1 if there is a date in A2 and zero if it is blank.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
